Query optimisation in real-time data warehouses
نویسندگان
چکیده
منابع مشابه
Striving towards Near Real-Time Data Integration for Data Warehouses
The amount of information available to large-scale enterprises is growing rapidly. While operational systems are designed to meet well-specified (short) response time requirements, the focus of data warehouses is generally the strategic analysis of business data integrated from heterogeneous source systems. The decision making process in traditional data warehouse environments is often delayed ...
متن کاملDynamic Query Scheduling in Parallel Data Warehouses
Parallel processing is a key to high performance in very large data warehouse applications that execute complex analytical queries on huge amounts of data. Although parallel database systems (PDBSs) have been studied extensively in the past decades, the specifics of load balancing in parallel data warehouses have not been addressed in detail. In this study, we investigate how the load balancing...
متن کاملQuery Performance Optimization in XML Data Warehouses
Decision-support applications aim at facilitating the decision-making process. They collect data from operational databases and various sources, transform them into information available to decision-makers in a consolidated and consistent manner (Kimball & Ross, 2002). Furthermore, the development of the Web 2.0 and the proliferation of multimedia documents contributed to the analysis of data a...
متن کاملQuery Processing Issues in Data Warehouses
Data warehouses store organizational data extracted from many operational databases. They are mainly used for decision support and OLAP applications. As a result, queries to a data warehouse have unique idiosyncrasies that have to be separately addressed. Data warehouse queries usually are much less frequent than OLTP queries and touch upon much more data than a typical OLTP query. In addition,...
متن کاملImproving Query Performance in Virtual Data Warehouses
In order to improve the quality of Business Intelligence Systems in an organization we can choose to build the system using BI techniques such as OLAP and data warehousing or by using traditional reports based on SQL queries. The cost and developing time for BI tools is greater than those for SQL Reports and these factors are important in taking decisions on what type of techniques we used for ...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
ژورنال
عنوان ژورنال: International Journal of Intelligent Information and Database Systems
سال: 2019
ISSN: 1751-5858,1751-5866
DOI: 10.1504/ijiids.2019.104534